Both SAS^® Enterprise Guide^® and the SAS^® Add-in for Microsoft Office enable you to create a type of line plot called Multiple line plots by group column. If you define the line plot with the following settings, an error might occur when you run the task.

• a variable is assigned to the optional Group charts by role
• the option Summarize for each distinct horizontal val is selected for the Vertical role, and the Function is set to Sum.

This is the error:

ERROR: Data set WORK.SORTTEMPTABLESORTED is not sorted in ascending sequence.
The current by-group has groupvar = VALUE2 and the next by-group has groupvar = VALUE1.

This error occurs because the PROC SQL that creates the summarized data places the group by and order by variables in the wrong order. To circumvent this problem, you can modify the generated code. Here are the steps:

1. In the Line Plot task window, assign your variables to desired task roles, and specify any other options for the plot.
2. Click Preview Code at the bottom of the window.
3. In the Code Preview for Task window, scroll down until you get to the TITLE; statement. Highlight and copy all of the code from the TITLE; statement down to and including the QUIT; statement.
4. Click Insert Code at the top of the window.
5. In the User Code window, scroll down to the TITLE; statement. Just above the statement, double click the shaded line: <Double-click to insert code>.
6. In the Enter User Code window, type /* , and then click OK.
7. In the User Code window, scroll down the code to the QUIT; statement. Just below the statement, double click the shaded line: <Double-click to insert code>.
8. In the Enter User Code window, type */ and then paste the code that you copied in step 3.
9. In the pasted code, change the variables on the GROUP BY and ORDER BY statements so that they are in the following order:
   1. the variable that you assigned to the Group charts by task role
   2. the variable that you assigned to the Group task role
   3. the variable that you assigned to the Horizontal axis task role

   For example:

   GROUP BY Group-byvar, Groupvar, Horizontalvar ORDER BY Group-byvar, Groupvar, Horizontalvar

10. Click OK to close the Enter User Code window.
11. Click OK to close the User Code window.
12. Click X in the upper, right-hand corner of the Preview Code window.

Operating System and Release Information